SPT_Data_Options
Casey Siesel
6/11/2020
SPT Data by FB classification
| sample_type | count_all | mean ec_conc (min-max).x | Typhi + %.x | Typhi pres %.x | Paratyphi + %.x | Paratyphi pres %.x | count_1 | mean ec_conc (min-max).y | Typhi + %.y | Typhi pres %.y | Paratyphi + %.y | Paratyphi pres %.y | count_2 | mean ec_conc (min-max).x.1 | Typhi + %.x.1 | Typhi pres %.x.1 | Paratyphi + %.x.1 | Paratyphi pres %.x.1 | count_3 | mean ec_conc (min-max).y.1 | Typhi + %.y.1 | Typhi pres %.y.1 | Paratyphi + %.y.1 | Paratyphi pres %.y.1 | count_4 | mean ec_conc (min-max) | Typhi + % | Typhi pres % | Paratyphi + % | Paratyphi pres % |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Bathing Water | 4 | 0.39(-0.3-1.78) | 0 | 0 | 0.00 | 0 | 4 | 0.39(-0.3-1.78) | 0 | 0 | 0.00 | 0 | 4 | 0.39(-0.3-1.78) | 0 | 0 | 0 | 0 | 4 | 0.39(-0.3-1.78) | 0 | 0 | 0.00 | 0 | 4 | 0.39(-0.3-1.78) | 0 | 0 | 0 | 0 |
| Drinking Water | 6 | 1.37(-0.3-4.7) | 0 | 0 | 0.00 | 0 | 6 | 1.37(-0.3-4.7) | 0 | 0 | 0.00 | 0 | 6 | 1.37(-0.3-4.7) | 0 | 0 | 0 | 0 | 6 | 1.37(-0.3-4.7) | 0 | 0 | 0.00 | 0 | 6 | 1.37(-0.3-4.7) | 0 | 0 | 0 | 0 |
| Public Latrine | 3 | 0.3(0.3-0.3) | 0 | 0 | 0.00 | 0 | 3 | 0.3(0.3-0.3) | 0 | 0 | 0.00 | 0 | 3 | 0.3(0.3-0.3) | 0 | 0 | 0 | 0 | 3 | 0.3(0.3-0.3) | 0 | 0 | 0.00 | 0 | 3 | 0.3(0.3-0.3) | 0 | 0 | 0 | 0 |
| Raw Produce | 7 | 4.09(1.4-7) | 0 | 0 | 0.00 | 0 | 7 | 4.09(1.4-7) | 0 | 0 | 0.00 | 0 | 7 | 4.09(1.4-7) | 0 | 0 | 0 | 0 | 7 | 4.09(1.4-7) | 0 | 0 | 0.00 | 0 | 7 | 4.09(1.4-7) | 0 | 0 | 0 | 0 |
| Soil | 6 | 2.26(1-3.56) | 0 | 0 | 16.67 | 0 | 6 | 2.26(1-3.56) | 0 | 0 | 16.67 | 0 | 5 | 1.93(1-2.92) | 0 | 0 | 20 | 0 | 6 | 2.26(1-3.56) | 0 | 0 | 16.67 | 0 | 5 | 1.93(1-2.92) | 0 | 0 | 20 | 0 |
| Street Food | 4 | 3.14(2.67-3.69) | 25 | 0 | 0.00 | 0 | 4 | 3.14(2.67-3.69) | 25 | 0 | 0.00 | 0 | 4 | 3.14(2.67-3.69) | 25 | 0 | 0 | 0 | 4 | 3.14(2.67-3.69) | 25 | 0 | 0.00 | 0 | 4 | 3.14(2.67-3.69) | 25 | 0 | 0 | 0 |
| Surface Water | 5 | 4.18(2.7-6.3) | 0 | 20 | 0.00 | 0 | 5 | 4.18(2.7-6.3) | 0 | 20 | 0.00 | 0 | 5 | 4.18(2.7-6.3) | 0 | 20 | 0 | 0 | 5 | 4.18(2.7-6.3) | 0 | 20 | 0.00 | 0 | 5 | 4.18(2.7-6.3) | 0 | 20 | 0 | 0 |
| a var_all = no removal, var_1 = only samples w/ FB, var_2 = only samples w/ no EC FB, var_3 = only samples w/ no PCR FB, var_4 = only samples with no EC or PCR FB |
ES Data by FB classification
| sample_type | count_all | mean ec_conc (min-max).x | Typhi + %.x | Typhi pres %.x | Paratyphi + %.x | Paratyphi pres %.x | count_1 | mean ec_conc (min-max).y | Typhi + %.y | Typhi pres %.y | Paratyphi + %.y | Paratyphi pres %.y | count_2 | mean ec_conc (min-max).x.1 | Typhi + %.x.1 | Typhi pres %.x.1 | Paratyphi + %.x.1 | Paratyphi pres %.x.1 | count_3 | mean ec_conc (min-max).y.1 | Typhi + %.y.1 | Typhi pres %.y.1 | Paratyphi + %.y.1 | Paratyphi pres %.y.1 | count_4 | mean ec_conc (min-max) | Typhi + % | Typhi pres % | Paratyphi + % | Paratyphi pres % |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Moore Swab | 139 | NaN(Inf–Inf) | 64.03 | 12.95 | 14.39 | 3.60 | 139 | NaN(Inf–Inf) | 64.03 | 12.95 | 14.39 | 3.60 | 138 | NaN(Inf–Inf) | 63.77 | 13.04 | 14.49 | 2.90 | 138 | NaN(Inf–Inf) | 63.77 | 13.04 | 14.49 | 3.62 | 137 | NaN(Inf–Inf) | 63.50 | 13.14 | 14.60 | 2.92 |
| Pooled Latrine | 12 | 5.48(4.7-7.19) | 8.33 | 33.33 | 0.00 | 0.00 | 12 | 5.48(4.7-7.19) | 8.33 | 33.33 | 0.00 | 0.00 | 12 | 5.48(4.7-7.19) | 8.33 | 33.33 | 0.00 | 0.00 | 12 | 5.48(4.7-7.19) | 8.33 | 33.33 | 0.00 | 0.00 | 12 | 5.48(4.7-7.19) | 8.33 | 33.33 | 0.00 | 0.00 |
| Pooled Latrine Case | 201 | 6.84(4.7-9.68) | 47.26 | 23.88 | 3.48 | 1.99 | 201 | 6.84(4.7-9.68) | 47.26 | 23.88 | 3.48 | 1.99 | 198 | 6.84(4.7-9.68) | 47.47 | 24.24 | 3.54 | 2.02 | 197 | 6.83(4.7-9.68) | 47.21 | 23.86 | 3.55 | 2.03 | 194 | 6.83(4.7-9.68) | 47.42 | 24.23 | 3.61 | 2.06 |
| Pumping Station - UF | 24 | 6.24(4.7-7.58) | 33.33 | 16.67 | 0.00 | 0.00 | 18 | 6.18(4.7-7.58) | 33.33 | 22.22 | 0.00 | 0.00 | 18 | 6.18(4.7-7.58) | 33.33 | 22.22 | 0.00 | 0.00 | 18 | 6.18(4.7-7.58) | 33.33 | 22.22 | 0.00 | 0.00 | 18 | 6.18(4.7-7.58) | 33.33 | 22.22 | 0.00 | 0.00 |
| a var_all = no removal, var_1 = only samples w/ FB, var_2 = only samples w/ no EC FB, var_3 = only samples w/ no PCR FB, var_4 = only samples with no EC or PCR FB |
SO Data by FB classification
| sample_type | count_all | mean ec_conc (min-max).x | Typhi + %.x | Typhi pres %.x | Paratyphi + %.x | Paratyphi pres %.x | count_1 | mean ec_conc (min-max).y | Typhi + %.y | Typhi pres %.y | Paratyphi + %.y | Paratyphi pres %.y | count_2 | mean ec_conc (min-max).x.1 | Typhi + %.x.1 | Typhi pres %.x.1 | Paratyphi + %.x.1 | Paratyphi pres %.x.1 | count_3 | mean ec_conc (min-max).y.1 | Typhi + %.y.1 | Typhi pres %.y.1 | Paratyphi + %.y.1 | Paratyphi pres %.y.1 | count_4 | mean ec_conc (min-max) | Typhi + % | Typhi pres % | Paratyphi + % | Paratyphi pres % |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Child Obs - Floor | 12 | 3.68(2.3-5.08) | 0.00 | 0.00 | 0 | 0 | 12 | 3.68(2.3-5.08) | 0.00 | 0.00 | 0 | 0 | 11 | 3.61(2.3-5.08) | 0.00 | 0 | 0.00 | 0 | 12 | 3.68(2.3-5.08) | 0.00 | 0.00 | 0 | 0 | 11 | 3.61(2.3-5.08) | 0.00 | 0 | 0.00 | 0 |
| Child Obs - Off Ground | 35 | 2.81(2.3-4.6) | 0.00 | 2.86 | 0 | 0 | 35 | 2.81(2.3-4.6) | 0.00 | 2.86 | 0 | 0 | 28 | 2.88(2.3-4.6) | 0.00 | 0 | 0.00 | 0 | 35 | 2.81(2.3-4.6) | 0.00 | 2.86 | 0 | 0 | 28 | 2.88(2.3-4.6) | 0.00 | 0 | 0.00 | 0 |
| Cooking/Preparation Utensil (FPe) | 10 | 0.38(-0.3-3.48) | 0.00 | 0.00 | 10 | 0 | 10 | 0.38(-0.3-3.48) | 0.00 | 0.00 | 10 | 0 | 9 | 0.04(-0.3-1.23) | 0.00 | 0 | 11.11 | 0 | 10 | 0.38(-0.3-3.48) | 0.00 | 0.00 | 10 | 0 | 9 | 0.04(-0.3-1.23) | 0.00 | 0 | 11.11 | 0 |
| Cooking/Preparation Water (FPd) | 10 | 0.06(-0.3-2.15) | 0.00 | 0.00 | 0 | 0 | 10 | 0.06(-0.3-2.15) | 0.00 | 0.00 | 0 | 0 | 9 | -0.17(-0.3-0.6) | 0.00 | 0 | 0.00 | 0 | 10 | 0.06(-0.3-2.15) | 0.00 | 0.00 | 0 | 0 | 9 | -0.17(-0.3-0.6) | 0.00 | 0 | 0.00 | 0 |
| Cutting /Grinding Surface (FPa) | 10 | 2.88(1.6-4.2) | 10.00 | 0.00 | 0 | 0 | 10 | 2.88(1.6-4.2) | 10.00 | 0.00 | 0 | 0 | 9 | 2.88(1.6-4.2) | 11.11 | 0 | 0.00 | 0 | 10 | 2.88(1.6-4.2) | 10.00 | 0.00 | 0 | 0 | 9 | 2.88(1.6-4.2) | 11.11 | 0 | 0.00 | 0 |
| Food Preparation Area (FPc) | 11 | 3.02(0.3-4.94) | 0.00 | 0.00 | 0 | 0 | 11 | 3.02(0.3-4.94) | 0.00 | 0.00 | 0 | 0 | 9 | 3.27(2.3-4.94) | 0.00 | 0 | 0.00 | 0 | 11 | 3.02(0.3-4.94) | 0.00 | 0.00 | 0 | 0 | 9 | 3.27(2.3-4.94) | 0.00 | 0 | 0.00 | 0 |
| Storage/Preparation Bowl (FPb) | 9 | 0.81(-0.3-3.3) | 11.11 | 0.00 | 0 | 0 | 9 | 0.81(-0.3-3.3) | 11.11 | 0.00 | 0 | 0 | 9 | 0.81(-0.3-3.3) | 11.11 | 0 | 0.00 | 0 | 9 | 0.81(-0.3-3.3) | 11.11 | 0.00 | 0 | 0 | 9 | 0.81(-0.3-3.3) | 11.11 | 0 | 0.00 | 0 |
| a var_all = no removal, var_1 = only samples w/ FB, var_2 = only samples w/ no EC FB, var_3 = only samples w/ no PCR FB, var_4 = only samples with no EC or PCR FB |
